﻿CREATE PROCEDURE [dbo].[yaf_nntpserver_list](
                @BoardID      INT  = NULL,
                @NntpServerID INT  = NULL)
AS
    BEGIN
        IF @NntpServerID IS NULL
        SELECT   *
        FROM     yaf_NntpServer
        WHERE    BoardID = @BoardID
        ORDER BY Name
        ELSE
        SELECT *
        FROM   yaf_NntpServer
        WHERE  NntpServerID = @NntpServerID
    END


